{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tushare as ts  \n",
    "import pandas as pd  \n",
    "from sqlalchemy import create_engine  \n",
    "import sqlalchemy\n",
    "import mysql.connector\n",
    "try:\n",
    "    conn = mysql.connector.connect(user='diagnose_report', password='launch@1234',\n",
    "                                   host='rm-wz9v9e07mh753tk321o.mysql.rds.aliyuncs.com',\n",
    "                                   database='car_spider')\n",
    "except mysql.connector.Error as err:\n",
    "    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:\n",
    "        print(\"Something is wrong with your user name or password\")\n",
    "    elif err.errno == errorcode.ER_BAD_DB_ERROR:\n",
    "        print(\"Database does not exist\")\n",
    "    else:\n",
    "        print(err)\n",
    "cursor = conn.cursor()\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_jc\")\n",
    "results = cursor.fetchall()\n",
    "jc = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_suv\")\n",
    "results = cursor.fetchall()\n",
    "suv = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "suv = suv.drop([8682,8723,8857,8858,9948,9949,10086,10202,10341,10342,10343,10361,10386])\n",
    "all1 = jc.append(suv)\n",
    "cursor.execute(\"select `factory`,`brand`,`style`,`style_1`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`engine_displacement`,`最大功率[kW]` from car_price_detail\")\n",
    "results = cursor.fetchall()\n",
    "price = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop\")\n",
    "results = cursor.fetchall()\n",
    "price2 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop_1\")\n",
    "results = cursor.fetchall()\n",
    "price3 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "price = price.append(price2)\n",
    "price = price.append(price3)\n",
    "conn.commit()\n",
    "cursor.close()\n",
    "conn.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [],
   "source": [
    "LSG_price = price[(price['brand']=='福田')|(price['brand']=='宝沃')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['宝沃汽车>>', '宝沃新能源>>', '福田商用车>>', '福田汽车>>', '福田商用车新能源>>'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price.factory.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [],
   "source": [
    "all1['3']=all1['vin'].apply(lambda x :x[:3])\n",
    "LSG = all1[(all1['3']=='LVA')|(all1['3']=='LVC')|(all1['3']=='LXV')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>notice_type</th>\n",
       "      <th>brand_x</th>\n",
       "      <th>curb_weight</th>\n",
       "      <th>Wheelbase</th>\n",
       "      <th>car_length</th>\n",
       "      <th>car_width</th>\n",
       "      <th>car_height</th>\n",
       "      <th>Displacement</th>\n",
       "      <th>power</th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>3</th>\n",
       "      <th>轴距[mm]</th>\n",
       "      <th>长×宽×高[mm]</th>\n",
       "      <th>brand_y</th>\n",
       "      <th>style</th>\n",
       "      <th>factory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BW6470B1Y5B</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1886</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1981</td>\n",
       "      <td>148</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BW6474B1Y5B</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1886</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1797</td>\n",
       "      <td>140</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BW6470B1Y5B</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1886</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1981</td>\n",
       "      <td>148</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BW6470B1Y5B</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1886</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1981</td>\n",
       "      <td>148</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BW6460A4Y5J</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1670</td>\n",
       "      <td>2685</td>\n",
       "      <td>4601</td>\n",
       "      <td>1877</td>\n",
       "      <td>1656</td>\n",
       "      <td>1981</td>\n",
       "      <td>165</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2685</td>\n",
       "      <td>4601x1877x1656</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>BW6460A4Y5J</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1670</td>\n",
       "      <td>2685</td>\n",
       "      <td>4601</td>\n",
       "      <td>1877</td>\n",
       "      <td>1656</td>\n",
       "      <td>1981</td>\n",
       "      <td>165</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2685</td>\n",
       "      <td>4601x1877x1656</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>BW6471B1Y5A</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1779</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1981</td>\n",
       "      <td>165</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>BW6473B1Y5A</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1779</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1981</td>\n",
       "      <td>165</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>BW6471B1Y5A</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1779</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1981</td>\n",
       "      <td>165</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>BW6471B1Y5A</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1779</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1981</td>\n",
       "      <td>165</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>BW6470B1Y5A</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1779</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1981</td>\n",
       "      <td>148</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>BJ6518BDDVA-K5</td>\n",
       "      <td>福田</td>\n",
       "      <td>2130</td>\n",
       "      <td>2933</td>\n",
       "      <td>5065</td>\n",
       "      <td>2000</td>\n",
       "      <td>2445</td>\n",
       "      <td>1981</td>\n",
       "      <td>148</td>\n",
       "      <td>LVCP2FVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2933</td>\n",
       "      <td>5065x2000x2445</td>\n",
       "      <td>福田</td>\n",
       "      <td>图雅诺</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>BJ6518BDDVA-P5</td>\n",
       "      <td>福田</td>\n",
       "      <td>2130</td>\n",
       "      <td>2933</td>\n",
       "      <td>5065</td>\n",
       "      <td>2000</td>\n",
       "      <td>2445</td>\n",
       "      <td>1981</td>\n",
       "      <td>148</td>\n",
       "      <td>LVCP2FVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2933</td>\n",
       "      <td>5065x2000x2445</td>\n",
       "      <td>福田</td>\n",
       "      <td>图雅诺</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>BW6474B1X5A</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1668</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1797</td>\n",
       "      <td>140</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>BW6473B1X5A</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1668</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1981</td>\n",
       "      <td>165</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>BW6471B1X5A</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1668</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1981</td>\n",
       "      <td>165</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>BW6471B1X5A</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1668</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1981</td>\n",
       "      <td>165</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>BW6470B1X5A</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>1668</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715</td>\n",
       "      <td>1911</td>\n",
       "      <td>1690</td>\n",
       "      <td>1981</td>\n",
       "      <td>148</td>\n",
       "      <td>LXVD3GFC×××××××××</td>\n",
       "      <td>北京宝沃汽车有限公司</td>\n",
       "      <td>LXV</td>\n",
       "      <td>2760</td>\n",
       "      <td>4715x1911x1690</td>\n",
       "      <td>宝沃</td>\n",
       "      <td>宝沃BX7</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>BJ6477MD62A-M1</td>\n",
       "      <td>福田</td>\n",
       "      <td>1435</td>\n",
       "      <td>2760</td>\n",
       "      <td>4700</td>\n",
       "      <td>1780</td>\n",
       "      <td>1820</td>\n",
       "      <td>1498</td>\n",
       "      <td>85</td>\n",
       "      <td>LVCP2GVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2760</td>\n",
       "      <td>4700x1780x1820</td>\n",
       "      <td>福田</td>\n",
       "      <td>伽途im</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>BJ6477MD62A-M2</td>\n",
       "      <td>福田</td>\n",
       "      <td>1435</td>\n",
       "      <td>2760</td>\n",
       "      <td>4700</td>\n",
       "      <td>1780</td>\n",
       "      <td>1820</td>\n",
       "      <td>1498</td>\n",
       "      <td>85</td>\n",
       "      <td>LVCP2GVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2760</td>\n",
       "      <td>4700x1780x1820</td>\n",
       "      <td>福田</td>\n",
       "      <td>伽途im</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>BJ6477MD62A-M2</td>\n",
       "      <td>福田</td>\n",
       "      <td>1435</td>\n",
       "      <td>2760</td>\n",
       "      <td>4700</td>\n",
       "      <td>1780</td>\n",
       "      <td>1820</td>\n",
       "      <td>1498</td>\n",
       "      <td>85</td>\n",
       "      <td>LVCP2GVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2760</td>\n",
       "      <td>4700x1780x1820</td>\n",
       "      <td>福田</td>\n",
       "      <td>伽途im</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>BJ6477MD62A-M1</td>\n",
       "      <td>福田</td>\n",
       "      <td>1435</td>\n",
       "      <td>2760</td>\n",
       "      <td>4700</td>\n",
       "      <td>1780</td>\n",
       "      <td>1820</td>\n",
       "      <td>1498</td>\n",
       "      <td>85</td>\n",
       "      <td>LVCP2GVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2760</td>\n",
       "      <td>4700x1780x1820</td>\n",
       "      <td>福田</td>\n",
       "      <td>伽途im</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>BJ6477MD62A-H2</td>\n",
       "      <td>福田</td>\n",
       "      <td>1435</td>\n",
       "      <td>2760</td>\n",
       "      <td>4700</td>\n",
       "      <td>1780</td>\n",
       "      <td>1820</td>\n",
       "      <td>1499</td>\n",
       "      <td>81</td>\n",
       "      <td>LVCP2GVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2760</td>\n",
       "      <td>4700x1780x1820</td>\n",
       "      <td>福田</td>\n",
       "      <td>伽途im</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>BJ6477MD62A-H1</td>\n",
       "      <td>福田</td>\n",
       "      <td>1435</td>\n",
       "      <td>2760</td>\n",
       "      <td>4700</td>\n",
       "      <td>1780</td>\n",
       "      <td>1820</td>\n",
       "      <td>1499</td>\n",
       "      <td>81</td>\n",
       "      <td>LVCP2GVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2760</td>\n",
       "      <td>4700x1780x1820</td>\n",
       "      <td>福田</td>\n",
       "      <td>伽途im</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>BJ6477MD62A-H1</td>\n",
       "      <td>福田</td>\n",
       "      <td>1435</td>\n",
       "      <td>2760</td>\n",
       "      <td>4700</td>\n",
       "      <td>1780</td>\n",
       "      <td>1820</td>\n",
       "      <td>1499</td>\n",
       "      <td>81</td>\n",
       "      <td>LVCP2GVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2760</td>\n",
       "      <td>4700x1780x1820</td>\n",
       "      <td>福田</td>\n",
       "      <td>伽途im</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>BJ6477MD62A-M2</td>\n",
       "      <td>福田</td>\n",
       "      <td>1435</td>\n",
       "      <td>2760</td>\n",
       "      <td>4700</td>\n",
       "      <td>1780</td>\n",
       "      <td>1820</td>\n",
       "      <td>1498</td>\n",
       "      <td>85</td>\n",
       "      <td>LVCP2GVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2760</td>\n",
       "      <td>4700x1780x1820</td>\n",
       "      <td>福田</td>\n",
       "      <td>伽途im</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>BJ6477MD62A-M1</td>\n",
       "      <td>福田</td>\n",
       "      <td>1435</td>\n",
       "      <td>2760</td>\n",
       "      <td>4700</td>\n",
       "      <td>1780</td>\n",
       "      <td>1820</td>\n",
       "      <td>1498</td>\n",
       "      <td>85</td>\n",
       "      <td>LVCP2GVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2760</td>\n",
       "      <td>4700x1780x1820</td>\n",
       "      <td>福田</td>\n",
       "      <td>伽途im</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>BJ6477MD62A-H2</td>\n",
       "      <td>福田</td>\n",
       "      <td>1435</td>\n",
       "      <td>2760</td>\n",
       "      <td>4700</td>\n",
       "      <td>1780</td>\n",
       "      <td>1820</td>\n",
       "      <td>1499</td>\n",
       "      <td>81</td>\n",
       "      <td>LVCP2GVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2760</td>\n",
       "      <td>4700x1780x1820</td>\n",
       "      <td>福田</td>\n",
       "      <td>伽途im</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>BJ6477MD62A-N3</td>\n",
       "      <td>福田</td>\n",
       "      <td>1435</td>\n",
       "      <td>2760</td>\n",
       "      <td>4730</td>\n",
       "      <td>1810</td>\n",
       "      <td>1830</td>\n",
       "      <td>1395</td>\n",
       "      <td>110</td>\n",
       "      <td>LVCP2GVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2760</td>\n",
       "      <td>4730x1810x1830</td>\n",
       "      <td>福田</td>\n",
       "      <td>伽途GT</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>BJ6477MD62A-N3</td>\n",
       "      <td>福田</td>\n",
       "      <td>1435</td>\n",
       "      <td>2760</td>\n",
       "      <td>4730</td>\n",
       "      <td>1810</td>\n",
       "      <td>1830</td>\n",
       "      <td>1395</td>\n",
       "      <td>110</td>\n",
       "      <td>LVCP2GVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2760</td>\n",
       "      <td>4730x1810x1830</td>\n",
       "      <td>福田</td>\n",
       "      <td>伽途im</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>BJ6486MD6VA-XB</td>\n",
       "      <td>福田</td>\n",
       "      <td>1930</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800</td>\n",
       "      <td>1825</td>\n",
       "      <td>1950</td>\n",
       "      <td>1998</td>\n",
       "      <td>95</td>\n",
       "      <td>LVCP2GVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800x1825x1950</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>BJ6486MD6XA-XA</td>\n",
       "      <td>福田</td>\n",
       "      <td>1930</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800</td>\n",
       "      <td>1825</td>\n",
       "      <td>1950</td>\n",
       "      <td>2351</td>\n",
       "      <td>89.5</td>\n",
       "      <td>LVCP2GWA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800x1825x1950</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>BJ6486MD6VA-XA</td>\n",
       "      <td>福田</td>\n",
       "      <td>1930</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800</td>\n",
       "      <td>1825</td>\n",
       "      <td>1950</td>\n",
       "      <td>1997</td>\n",
       "      <td>90</td>\n",
       "      <td>LVCP2GVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800x1825x1950</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>BJ6486MD6VA-V1</td>\n",
       "      <td>福田</td>\n",
       "      <td>1930</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800</td>\n",
       "      <td>1825</td>\n",
       "      <td>1950</td>\n",
       "      <td>1997</td>\n",
       "      <td>90</td>\n",
       "      <td>LVCP2GVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800x1825x1950</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>BJ6486MD6XA-V1</td>\n",
       "      <td>福田</td>\n",
       "      <td>1930</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800</td>\n",
       "      <td>1825</td>\n",
       "      <td>1950</td>\n",
       "      <td>2378</td>\n",
       "      <td>100</td>\n",
       "      <td>LVCP2GWA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800x1825x1950</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>BJ6486BDEVA-A5</td>\n",
       "      <td>福田</td>\n",
       "      <td>1930</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800</td>\n",
       "      <td>1825</td>\n",
       "      <td>1950</td>\n",
       "      <td>1997</td>\n",
       "      <td>90</td>\n",
       "      <td>LVCB2PVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800x1825x1950</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>BJ6486BDEXA-A5</td>\n",
       "      <td>福田</td>\n",
       "      <td>1930</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800</td>\n",
       "      <td>1825</td>\n",
       "      <td>1950</td>\n",
       "      <td>2378</td>\n",
       "      <td>100</td>\n",
       "      <td>LVCP2GWA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800x1825x1950</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>BJ6486MD6VA-V1</td>\n",
       "      <td>福田</td>\n",
       "      <td>1930</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800</td>\n",
       "      <td>1825</td>\n",
       "      <td>1950</td>\n",
       "      <td>1997</td>\n",
       "      <td>90</td>\n",
       "      <td>LVCP2GVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800x1825x1950</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>BJ6486MD6XA-V1</td>\n",
       "      <td>福田</td>\n",
       "      <td>1930</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800</td>\n",
       "      <td>1825</td>\n",
       "      <td>1950</td>\n",
       "      <td>2378</td>\n",
       "      <td>100</td>\n",
       "      <td>LVCP2GWA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800x1825x1950</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>BJ6486MD6XA-XA</td>\n",
       "      <td>福田</td>\n",
       "      <td>1930</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800</td>\n",
       "      <td>1825</td>\n",
       "      <td>1950</td>\n",
       "      <td>2351</td>\n",
       "      <td>89.5</td>\n",
       "      <td>LVCP2GWA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800x1825x1950</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>BJ6486MD6VA-XA</td>\n",
       "      <td>福田</td>\n",
       "      <td>1930</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800</td>\n",
       "      <td>1825</td>\n",
       "      <td>1950</td>\n",
       "      <td>1997</td>\n",
       "      <td>90</td>\n",
       "      <td>LVCP2GVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800x1825x1950</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>BJ6486MD6VA-XB</td>\n",
       "      <td>福田</td>\n",
       "      <td>1930</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800</td>\n",
       "      <td>1825</td>\n",
       "      <td>1950</td>\n",
       "      <td>1998</td>\n",
       "      <td>95</td>\n",
       "      <td>LVCP2GVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800x1825x1950</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>BJ6486BDEXA-A5</td>\n",
       "      <td>福田</td>\n",
       "      <td>1930</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800</td>\n",
       "      <td>1825</td>\n",
       "      <td>1950</td>\n",
       "      <td>2378</td>\n",
       "      <td>100</td>\n",
       "      <td>LVCP2GWA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800x1825x1950</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>BJ6486BDEVA-A5</td>\n",
       "      <td>福田</td>\n",
       "      <td>1930</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800</td>\n",
       "      <td>1825</td>\n",
       "      <td>1950</td>\n",
       "      <td>1997</td>\n",
       "      <td>90</td>\n",
       "      <td>LVCB2PVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800x1825x1950</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>BJ6486BDEVA-A5</td>\n",
       "      <td>福田</td>\n",
       "      <td>1930</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800</td>\n",
       "      <td>1825</td>\n",
       "      <td>1950</td>\n",
       "      <td>1997</td>\n",
       "      <td>90</td>\n",
       "      <td>LVCB2PVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800x1825x1950</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>BJ6486BDEXA-A5</td>\n",
       "      <td>福田</td>\n",
       "      <td>1930</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800</td>\n",
       "      <td>1825</td>\n",
       "      <td>1950</td>\n",
       "      <td>2378</td>\n",
       "      <td>100</td>\n",
       "      <td>LVCP2GWA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2985</td>\n",
       "      <td>4800x1825x1950</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>BJ6393MD31A-C2</td>\n",
       "      <td>福田</td>\n",
       "      <td>1025</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915</td>\n",
       "      <td>1640</td>\n",
       "      <td>1845</td>\n",
       "      <td>995</td>\n",
       "      <td>50</td>\n",
       "      <td>LVCP2DVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915x1640x1845</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景V3</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>BJ6393MD32A-A2</td>\n",
       "      <td>福田</td>\n",
       "      <td>1025</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915</td>\n",
       "      <td>1640</td>\n",
       "      <td>1845</td>\n",
       "      <td>1206</td>\n",
       "      <td>63</td>\n",
       "      <td>LVCP2DVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915x1640x1845</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景V3</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>BJ6393MD31A-CB</td>\n",
       "      <td>福田</td>\n",
       "      <td>1025</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915</td>\n",
       "      <td>1640</td>\n",
       "      <td>1845</td>\n",
       "      <td>995</td>\n",
       "      <td>50</td>\n",
       "      <td>LVCP2DVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915x1640x1845</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景V3</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>BJ6393MD32A-AB</td>\n",
       "      <td>福田</td>\n",
       "      <td>1025</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915</td>\n",
       "      <td>1640</td>\n",
       "      <td>1845</td>\n",
       "      <td>1206</td>\n",
       "      <td>63</td>\n",
       "      <td>LVCP2DVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>2500</td>\n",
       "      <td>3915x1640x1845</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景V3</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>BJ6539BDPVA-AC</td>\n",
       "      <td>福田</td>\n",
       "      <td>1990</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320</td>\n",
       "      <td>1695</td>\n",
       "      <td>2240</td>\n",
       "      <td>1998</td>\n",
       "      <td>95</td>\n",
       "      <td>LVCP2FVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320x1695x2240</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景G7</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>BJ6539BDPDA-CD</td>\n",
       "      <td>福田</td>\n",
       "      <td>1990</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320</td>\n",
       "      <td>1695</td>\n",
       "      <td>2240</td>\n",
       "      <td>2771</td>\n",
       "      <td>70</td>\n",
       "      <td>LVCP2FBA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320x1695x2240</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景G7</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>BJ6539BDPVA-A5</td>\n",
       "      <td>福田</td>\n",
       "      <td>1990</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320</td>\n",
       "      <td>1695</td>\n",
       "      <td>2240</td>\n",
       "      <td>1998</td>\n",
       "      <td>95</td>\n",
       "      <td>LVCP2FVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320x1695x2240</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景G7</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>BJ6539BDPVA-AC</td>\n",
       "      <td>福田</td>\n",
       "      <td>1990</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320</td>\n",
       "      <td>1695</td>\n",
       "      <td>2240</td>\n",
       "      <td>1998</td>\n",
       "      <td>95</td>\n",
       "      <td>LVCP2FVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320x1695x2240</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景G7</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>BJ6539BDPDA-CD</td>\n",
       "      <td>福田</td>\n",
       "      <td>1990</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320</td>\n",
       "      <td>1695</td>\n",
       "      <td>2240</td>\n",
       "      <td>2771</td>\n",
       "      <td>70</td>\n",
       "      <td>LVCP2FBA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320x1695x2240</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景G7</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>BJ6539BDPVA-CC</td>\n",
       "      <td>福田</td>\n",
       "      <td>1885</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320</td>\n",
       "      <td>1695</td>\n",
       "      <td>2240</td>\n",
       "      <td>1998</td>\n",
       "      <td>95</td>\n",
       "      <td>LVCP2FVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320x1695x2240</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景G7</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>BJ6539BDPVA-C5</td>\n",
       "      <td>福田</td>\n",
       "      <td>1885</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320</td>\n",
       "      <td>1695</td>\n",
       "      <td>2240</td>\n",
       "      <td>1998</td>\n",
       "      <td>95</td>\n",
       "      <td>LVCP2FVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320x1695x2240</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景G7</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>BJ6539BDPVA-CC</td>\n",
       "      <td>福田</td>\n",
       "      <td>1885</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320</td>\n",
       "      <td>1695</td>\n",
       "      <td>2240</td>\n",
       "      <td>1998</td>\n",
       "      <td>95</td>\n",
       "      <td>LVCP2FVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3050</td>\n",
       "      <td>5320x1695x2240</td>\n",
       "      <td>福田</td>\n",
       "      <td>风景G7</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>134</th>\n",
       "      <td>BJ6526BDDVA-A5</td>\n",
       "      <td>福田</td>\n",
       "      <td>2010</td>\n",
       "      <td>3430</td>\n",
       "      <td>5245</td>\n",
       "      <td>1825</td>\n",
       "      <td>1950</td>\n",
       "      <td>1997</td>\n",
       "      <td>90</td>\n",
       "      <td>LVCB2NVA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3430</td>\n",
       "      <td>5245x1825x1950</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>BJ6526BDDXA-A5</td>\n",
       "      <td>福田</td>\n",
       "      <td>2010</td>\n",
       "      <td>3430</td>\n",
       "      <td>5245</td>\n",
       "      <td>1825</td>\n",
       "      <td>1950</td>\n",
       "      <td>2378</td>\n",
       "      <td>100</td>\n",
       "      <td>LVCP2FWA×××××××××</td>\n",
       "      <td>北汽福田汽车股份有限公司</td>\n",
       "      <td>LVC</td>\n",
       "      <td>3430</td>\n",
       "      <td>5245x1825x1950</td>\n",
       "      <td>福田</td>\n",
       "      <td>蒙派克E</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>136 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        notice_type brand_x curb_weight Wheelbase car_length car_width  \\\n",
       "0       BW6470B1Y5B      宝沃        1886      2760       4715      1911   \n",
       "1       BW6474B1Y5B      宝沃        1886      2760       4715      1911   \n",
       "2       BW6470B1Y5B      宝沃        1886      2760       4715      1911   \n",
       "3       BW6470B1Y5B      宝沃        1886      2760       4715      1911   \n",
       "4       BW6460A4Y5J      宝沃        1670      2685       4601      1877   \n",
       "5       BW6460A4Y5J      宝沃        1670      2685       4601      1877   \n",
       "6       BW6471B1Y5A      宝沃        1779      2760       4715      1911   \n",
       "7       BW6473B1Y5A      宝沃        1779      2760       4715      1911   \n",
       "8       BW6471B1Y5A      宝沃        1779      2760       4715      1911   \n",
       "9       BW6471B1Y5A      宝沃        1779      2760       4715      1911   \n",
       "10      BW6470B1Y5A      宝沃        1779      2760       4715      1911   \n",
       "11   BJ6518BDDVA-K5      福田        2130      2933       5065      2000   \n",
       "12   BJ6518BDDVA-P5      福田        2130      2933       5065      2000   \n",
       "13      BW6474B1X5A      宝沃        1668      2760       4715      1911   \n",
       "14      BW6473B1X5A      宝沃        1668      2760       4715      1911   \n",
       "15      BW6471B1X5A      宝沃        1668      2760       4715      1911   \n",
       "16      BW6471B1X5A      宝沃        1668      2760       4715      1911   \n",
       "17      BW6470B1X5A      宝沃        1668      2760       4715      1911   \n",
       "18   BJ6477MD62A-M1      福田        1435      2760       4700      1780   \n",
       "19   BJ6477MD62A-M2      福田        1435      2760       4700      1780   \n",
       "20   BJ6477MD62A-M2      福田        1435      2760       4700      1780   \n",
       "21   BJ6477MD62A-M1      福田        1435      2760       4700      1780   \n",
       "22   BJ6477MD62A-H2      福田        1435      2760       4700      1780   \n",
       "23   BJ6477MD62A-H1      福田        1435      2760       4700      1780   \n",
       "24   BJ6477MD62A-H1      福田        1435      2760       4700      1780   \n",
       "25   BJ6477MD62A-M2      福田        1435      2760       4700      1780   \n",
       "26   BJ6477MD62A-M1      福田        1435      2760       4700      1780   \n",
       "27   BJ6477MD62A-H2      福田        1435      2760       4700      1780   \n",
       "28   BJ6477MD62A-N3      福田        1435      2760       4730      1810   \n",
       "29   BJ6477MD62A-N3      福田        1435      2760       4730      1810   \n",
       "..              ...     ...         ...       ...        ...       ...   \n",
       "106  BJ6486MD6VA-XB      福田        1930      2985       4800      1825   \n",
       "107  BJ6486MD6XA-XA      福田        1930      2985       4800      1825   \n",
       "108  BJ6486MD6VA-XA      福田        1930      2985       4800      1825   \n",
       "109  BJ6486MD6VA-V1      福田        1930      2985       4800      1825   \n",
       "110  BJ6486MD6XA-V1      福田        1930      2985       4800      1825   \n",
       "111  BJ6486BDEVA-A5      福田        1930      2985       4800      1825   \n",
       "112  BJ6486BDEXA-A5      福田        1930      2985       4800      1825   \n",
       "113  BJ6486MD6VA-V1      福田        1930      2985       4800      1825   \n",
       "114  BJ6486MD6XA-V1      福田        1930      2985       4800      1825   \n",
       "115  BJ6486MD6XA-XA      福田        1930      2985       4800      1825   \n",
       "116  BJ6486MD6VA-XA      福田        1930      2985       4800      1825   \n",
       "117  BJ6486MD6VA-XB      福田        1930      2985       4800      1825   \n",
       "118  BJ6486BDEXA-A5      福田        1930      2985       4800      1825   \n",
       "119  BJ6486BDEVA-A5      福田        1930      2985       4800      1825   \n",
       "120  BJ6486BDEVA-A5      福田        1930      2985       4800      1825   \n",
       "121  BJ6486BDEXA-A5      福田        1930      2985       4800      1825   \n",
       "122  BJ6393MD31A-C2      福田        1025      2500       3915      1640   \n",
       "123  BJ6393MD32A-A2      福田        1025      2500       3915      1640   \n",
       "124  BJ6393MD31A-CB      福田        1025      2500       3915      1640   \n",
       "125  BJ6393MD32A-AB      福田        1025      2500       3915      1640   \n",
       "126  BJ6539BDPVA-AC      福田        1990      3050       5320      1695   \n",
       "127  BJ6539BDPDA-CD      福田        1990      3050       5320      1695   \n",
       "128  BJ6539BDPVA-A5      福田        1990      3050       5320      1695   \n",
       "129  BJ6539BDPVA-AC      福田        1990      3050       5320      1695   \n",
       "130  BJ6539BDPDA-CD      福田        1990      3050       5320      1695   \n",
       "131  BJ6539BDPVA-CC      福田        1885      3050       5320      1695   \n",
       "132  BJ6539BDPVA-C5      福田        1885      3050       5320      1695   \n",
       "133  BJ6539BDPVA-CC      福田        1885      3050       5320      1695   \n",
       "134  BJ6526BDDVA-A5      福田        2010      3430       5245      1825   \n",
       "135  BJ6526BDDXA-A5      福田        2010      3430       5245      1825   \n",
       "\n",
       "    car_height Displacement power                vin   car_factory    3  \\\n",
       "0         1690         1981   148  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "1         1690         1797   140  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "2         1690         1981   148  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "3         1690         1981   148  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "4         1656         1981   165  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "5         1656         1981   165  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "6         1690         1981   165  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "7         1690         1981   165  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "8         1690         1981   165  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "9         1690         1981   165  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "10        1690         1981   148  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "11        2445         1981   148  LVCP2FVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "12        2445         1981   148  LVCP2FVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "13        1690         1797   140  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "14        1690         1981   165  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "15        1690         1981   165  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "16        1690         1981   165  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "17        1690         1981   148  LXVD3GFC×××××××××    北京宝沃汽车有限公司  LXV   \n",
       "18        1820         1498    85  LVCP2GVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "19        1820         1498    85  LVCP2GVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "20        1820         1498    85  LVCP2GVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "21        1820         1498    85  LVCP2GVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "22        1820         1499    81  LVCP2GVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "23        1820         1499    81  LVCP2GVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "24        1820         1499    81  LVCP2GVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "25        1820         1498    85  LVCP2GVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "26        1820         1498    85  LVCP2GVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "27        1820         1499    81  LVCP2GVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "28        1830         1395   110  LVCP2GVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "29        1830         1395   110  LVCP2GVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "..         ...          ...   ...                ...           ...  ...   \n",
       "106       1950         1998    95  LVCP2GVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "107       1950         2351  89.5  LVCP2GWA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "108       1950         1997    90  LVCP2GVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "109       1950         1997    90  LVCP2GVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "110       1950         2378   100  LVCP2GWA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "111       1950         1997    90  LVCB2PVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "112       1950         2378   100  LVCP2GWA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "113       1950         1997    90  LVCP2GVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "114       1950         2378   100  LVCP2GWA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "115       1950         2351  89.5  LVCP2GWA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "116       1950         1997    90  LVCP2GVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "117       1950         1998    95  LVCP2GVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "118       1950         2378   100  LVCP2GWA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "119       1950         1997    90  LVCB2PVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "120       1950         1997    90  LVCB2PVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "121       1950         2378   100  LVCP2GWA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "122       1845          995    50  LVCP2DVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "123       1845         1206    63  LVCP2DVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "124       1845          995    50  LVCP2DVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "125       1845         1206    63  LVCP2DVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "126       2240         1998    95  LVCP2FVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "127       2240         2771    70  LVCP2FBA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "128       2240         1998    95  LVCP2FVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "129       2240         1998    95  LVCP2FVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "130       2240         2771    70  LVCP2FBA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "131       2240         1998    95  LVCP2FVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "132       2240         1998    95  LVCP2FVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "133       2240         1998    95  LVCP2FVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "134       1950         1997    90  LVCB2NVA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "135       1950         2378   100  LVCP2FWA×××××××××  北汽福田汽车股份有限公司  LVC   \n",
       "\n",
       "    轴距[mm]       长×宽×高[mm] brand_y  style  factory  \n",
       "0     2760  4715x1911x1690      宝沃  宝沃BX7        3  \n",
       "1     2760  4715x1911x1690      宝沃  宝沃BX7        3  \n",
       "2     2760  4715x1911x1690      宝沃  宝沃BX7        3  \n",
       "3     2760  4715x1911x1690      宝沃  宝沃BX7        3  \n",
       "4     2685  4601x1877x1656      宝沃  宝沃BX6        1  \n",
       "5     2685  4601x1877x1656      宝沃  宝沃BX6        1  \n",
       "6     2760  4715x1911x1690      宝沃  宝沃BX7        4  \n",
       "7     2760  4715x1911x1690      宝沃  宝沃BX7        4  \n",
       "8     2760  4715x1911x1690      宝沃  宝沃BX7        4  \n",
       "9     2760  4715x1911x1690      宝沃  宝沃BX7        4  \n",
       "10    2760  4715x1911x1690      宝沃  宝沃BX7        4  \n",
       "11    2933  5065x2000x2445      福田    图雅诺        1  \n",
       "12    2933  5065x2000x2445      福田    图雅诺        1  \n",
       "13    2760  4715x1911x1690      宝沃  宝沃BX7        5  \n",
       "14    2760  4715x1911x1690      宝沃  宝沃BX7        5  \n",
       "15    2760  4715x1911x1690      宝沃  宝沃BX7        5  \n",
       "16    2760  4715x1911x1690      宝沃  宝沃BX7        5  \n",
       "17    2760  4715x1911x1690      宝沃  宝沃BX7        5  \n",
       "18    2760  4700x1780x1820      福田   伽途im        5  \n",
       "19    2760  4700x1780x1820      福田   伽途im        5  \n",
       "20    2760  4700x1780x1820      福田   伽途im        5  \n",
       "21    2760  4700x1780x1820      福田   伽途im        5  \n",
       "22    2760  4700x1780x1820      福田   伽途im        5  \n",
       "23    2760  4700x1780x1820      福田   伽途im        5  \n",
       "24    2760  4700x1780x1820      福田   伽途im        5  \n",
       "25    2760  4700x1780x1820      福田   伽途im        5  \n",
       "26    2760  4700x1780x1820      福田   伽途im        5  \n",
       "27    2760  4700x1780x1820      福田   伽途im        5  \n",
       "28    2760  4730x1810x1830      福田   伽途GT        4  \n",
       "29    2760  4730x1810x1830      福田   伽途im        6  \n",
       "..     ...             ...     ...    ...      ...  \n",
       "106   2985  4800x1825x1950      福田   蒙派克E        1  \n",
       "107   2985  4800x1825x1950      福田   蒙派克E        1  \n",
       "108   2985  4800x1825x1950      福田   蒙派克E        1  \n",
       "109   2985  4800x1825x1950      福田   蒙派克E        1  \n",
       "110   2985  4800x1825x1950      福田   蒙派克E        1  \n",
       "111   2985  4800x1825x1950      福田   蒙派克E        1  \n",
       "112   2985  4800x1825x1950      福田   蒙派克E        1  \n",
       "113   2985  4800x1825x1950      福田   蒙派克E        1  \n",
       "114   2985  4800x1825x1950      福田   蒙派克E        1  \n",
       "115   2985  4800x1825x1950      福田   蒙派克E        1  \n",
       "116   2985  4800x1825x1950      福田   蒙派克E        1  \n",
       "117   2985  4800x1825x1950      福田   蒙派克E        1  \n",
       "118   2985  4800x1825x1950      福田   蒙派克E        1  \n",
       "119   2985  4800x1825x1950      福田   蒙派克E        1  \n",
       "120   2985  4800x1825x1950      福田   蒙派克E        1  \n",
       "121   2985  4800x1825x1950      福田   蒙派克E        1  \n",
       "122   2500  3915x1640x1845      福田   风景V3       15  \n",
       "123   2500  3915x1640x1845      福田   风景V3       15  \n",
       "124   2500  3915x1640x1845      福田   风景V3       15  \n",
       "125   2500  3915x1640x1845      福田   风景V3       15  \n",
       "126   3050  5320x1695x2240      福田   风景G7        1  \n",
       "127   3050  5320x1695x2240      福田   风景G7        1  \n",
       "128   3050  5320x1695x2240      福田   风景G7        1  \n",
       "129   3050  5320x1695x2240      福田   风景G7        1  \n",
       "130   3050  5320x1695x2240      福田   风景G7        1  \n",
       "131   3050  5320x1695x2240      福田   风景G7        4  \n",
       "132   3050  5320x1695x2240      福田   风景G7        4  \n",
       "133   3050  5320x1695x2240      福田   风景G7        4  \n",
       "134   3430  5245x1825x1950      福田   蒙派克E        1  \n",
       "135   3430  5245x1825x1950      福田   蒙派克E        1  \n",
       "\n",
       "[136 rows x 17 columns]"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price = LSG_price[(LSG_price['长×宽×高[mm]']!='')]\n",
    "LSG_price['curb_weight'] =LSG_price['整备质量[kg]']\n",
    "LSG_price = LSG_price.groupby(['轴距[mm]','长×宽×高[mm]','brand','style','curb_weight'])['factory'].count().reset_index()\n",
    "LSG_price['car_length'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[0])\n",
    "LSG_price['car_width'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[1])\n",
    "LSG_price['car_height'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[2])\n",
    "LSG_price['Wheelbase'] =LSG_price['轴距[mm]']\n",
    "\n",
    "LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height','curb_weight'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {},
   "outputs": [],
   "source": [
    "#result = LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height','curb_weight'])\n",
    "result = LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])\n",
    "import re\n",
    "vin1 = []\n",
    "for a,i in result.iterrows():\n",
    "    a = re.findall(r'L[0-9A-Za-z]{7}×××××××××',i['vin'])\n",
    "    for j in a:\n",
    "        vin = []\n",
    "        vin.append(j)\n",
    "        vin.append(i['car_factory'].split(',')[0])\n",
    "        vin.append(i['brand_y'].split(',')[0])\n",
    "        vin.append(i['style'].split(',')[0])\n",
    "        vin1.append(vin)\n",
    "vin = pd.DataFrame(vin1,columns=['vin','car_factory','brand','style'])\n",
    "vin = vin.drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "vin.to_csv('宝沃_福田.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
